<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.20"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>libxlsxwriter: chartsheet.h File Reference</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="customdoxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectalign" style="padding-left: 0.5em;">
   <div id="projectname">libxlsxwriter
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.20 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
var searchBox = new SearchBox("searchBox", "search",false,'Search');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(function() {
  initMenu('',true,false,'search.php','Search');
  $(document).ready(function() { init_search(); });
});
/* @license-end */</script>
<div id="main-nav"></div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div id="nav-path" class="navpath">
  <ul>
<li class="navelem"><a class="el" href="dir_d44c64559bbebec7f509842c48db8b23.html">include</a></li><li class="navelem"><a class="el" href="dir_9a5cb1f80a06fe707e78a539c1c1dae8.html">xlsxwriter</a></li>  </ul>
</div>
</div><!-- top -->
<div class="header">
  <div class="summary">
<a href="#func-members">Functions</a> &#124;
<a href="#nested-classes">Data Structures</a> &#124;
<a href="#typedef-members">Typedefs</a>  </div>
  <div class="headertitle">
<div class="title">chartsheet.h File Reference</div>  </div>
</div><!--header-->
<div class="contents">
<a name="details" id="details"></a><h2 class="groupheader">Description</h2>
<div class="textblock"><p>The Chartsheet object represents an Excel chartsheet. It handles operations such as adding a chart and setting the page layout.</p>
<p>A Chartsheet object isn't created directly. Instead a chartsheet is created by calling the <a class="el" href="workbook_8h.html#a9cb69c057990a4139f0a19b53b04b805" title="Add a new chartsheet to a workbook.">workbook_add_chartsheet()</a> function from a Workbook object. A chartsheet object functions as a worksheet and not as a chart. In order to have it display data a <a class="el" href="structlxw__chart.html" title="Struct to represent an Excel chart.">lxw_chart</a> object must be created and added to the chartsheet:</p>
<div class="fragment"><div class="line"><span class="preprocessor">#include &quot;xlsxwriter.h&quot;</span></div>
<div class="line"> </div>
<div class="line"><span class="keywordtype">int</span> main() {</div>
<div class="line"> </div>
<div class="line">    <a class="code" href="structlxw__workbook.html">lxw_workbook</a>   *workbook   = new_workbook(<span class="stringliteral">&quot;chartsheet.xlsx&quot;</span>);</div>
<div class="line">    <a class="code" href="structlxw__worksheet.html">lxw_worksheet</a>  *worksheet  = <a class="code" href="workbook_8h.html#a81d456b4f65a464e78e4a0030ecc3c2e">workbook_add_worksheet</a>(workbook, NULL);</div>
<div class="line">    <a class="code" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet = <a class="code" href="workbook_8h.html#a9cb69c057990a4139f0a19b53b04b805">workbook_add_chartsheet</a>(workbook, NULL);</div>
<div class="line">    <a class="code" href="structlxw__chart.html">lxw_chart</a>      *chart      = <a class="code" href="workbook_8h.html#a63b001ecefdbc4417986a3e344657726">workbook_add_chart</a>(workbook, <a class="code" href="chart_8h.html#a9f577b0fcabe6cac9118a26a483fe85cab70e5b5cf00126d7040ab25af3b117d5">LXW_CHART_BAR</a>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">//... Set up the chart.</span></div>
<div class="line"> </div>
<div class="line">    <span class="comment">// Add the chart to the chartsheet.</span></div>
<div class="line">    <span class="keywordflow">return</span> <a class="code" href="workbook_8h.html#ad9e7aeebc0fd43562db5bcd527b2ee5e">workbook_close</a>(workbook);</div>
<div class="line"> </div>
<div class="line">}</div>
</div><!-- fragment --><div class="image">
<img src="chartsheet.png" alt=""/>
</div>
<p>The data for the chartsheet chart must be contained on a separate worksheet. That is why it is always created in conjunction with at least one data worksheet, as shown above. </p>
</div><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="func-members"></a>
Functions</h2></td></tr>
<tr class="memitem:a1c2cc87b14539396de75cd59ab2a6031"><td class="memItemLeft" align="right" valign="top"><a class="el" href="common_8h.html#a04b59aa3c578bc75f88ac16a979c5fe6">lxw_error</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#a1c2cc87b14539396de75cd59ab2a6031">chartsheet_set_chart</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet, <a class="el" href="structlxw__chart.html">lxw_chart</a> *chart)</td></tr>
<tr class="memdesc:a1c2cc87b14539396de75cd59ab2a6031"><td class="mdescLeft">&#160;</td><td class="mdescRight">Insert a chart object into a chartsheet.  <a href="chartsheet_8h.html#a1c2cc87b14539396de75cd59ab2a6031">More...</a><br /></td></tr>
<tr class="separator:a1c2cc87b14539396de75cd59ab2a6031"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a169a4a2ec5b7d57abe02feb9fc22023b"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#a169a4a2ec5b7d57abe02feb9fc22023b">chartsheet_activate</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet)</td></tr>
<tr class="memdesc:a169a4a2ec5b7d57abe02feb9fc22023b"><td class="mdescLeft">&#160;</td><td class="mdescRight">Make a chartsheet the active, i.e., visible chartsheet.  <a href="chartsheet_8h.html#a169a4a2ec5b7d57abe02feb9fc22023b">More...</a><br /></td></tr>
<tr class="separator:a169a4a2ec5b7d57abe02feb9fc22023b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a50e5acf866495f81e227bd99bc9f8e8b"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#a50e5acf866495f81e227bd99bc9f8e8b">chartsheet_select</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet)</td></tr>
<tr class="memdesc:a50e5acf866495f81e227bd99bc9f8e8b"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set a chartsheet tab as selected.  <a href="chartsheet_8h.html#a50e5acf866495f81e227bd99bc9f8e8b">More...</a><br /></td></tr>
<tr class="separator:a50e5acf866495f81e227bd99bc9f8e8b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a350f52a5de9988662af0f99f4592ac64"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#a350f52a5de9988662af0f99f4592ac64">chartsheet_hide</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet)</td></tr>
<tr class="memdesc:a350f52a5de9988662af0f99f4592ac64"><td class="mdescLeft">&#160;</td><td class="mdescRight">Hide the current chartsheet.  <a href="chartsheet_8h.html#a350f52a5de9988662af0f99f4592ac64">More...</a><br /></td></tr>
<tr class="separator:a350f52a5de9988662af0f99f4592ac64"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a54addfc00908f1c910ab12024a1deb7f"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#a54addfc00908f1c910ab12024a1deb7f">chartsheet_set_first_sheet</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet)</td></tr>
<tr class="memdesc:a54addfc00908f1c910ab12024a1deb7f"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set current chartsheet as the first visible sheet tab.  <a href="chartsheet_8h.html#a54addfc00908f1c910ab12024a1deb7f">More...</a><br /></td></tr>
<tr class="separator:a54addfc00908f1c910ab12024a1deb7f"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ad4128360dead5256f6ccdb2430b6a19b"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#ad4128360dead5256f6ccdb2430b6a19b">chartsheet_set_tab_color</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet, <a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a> color)</td></tr>
<tr class="memdesc:ad4128360dead5256f6ccdb2430b6a19b"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set the color of the chartsheet tab.  <a href="chartsheet_8h.html#ad4128360dead5256f6ccdb2430b6a19b">More...</a><br /></td></tr>
<tr class="separator:ad4128360dead5256f6ccdb2430b6a19b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a16d7a783d2b4ff43725d5e2b16c2eeef"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#a16d7a783d2b4ff43725d5e2b16c2eeef">chartsheet_protect</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet, const char *password, <a class="el" href="structlxw__protection.html">lxw_protection</a> *options)</td></tr>
<tr class="memdesc:a16d7a783d2b4ff43725d5e2b16c2eeef"><td class="mdescLeft">&#160;</td><td class="mdescRight">Protect elements of a chartsheet from modification.  <a href="chartsheet_8h.html#a16d7a783d2b4ff43725d5e2b16c2eeef">More...</a><br /></td></tr>
<tr class="separator:a16d7a783d2b4ff43725d5e2b16c2eeef"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a8e65099f374b986329f10ea9bfdcbce9"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#a8e65099f374b986329f10ea9bfdcbce9">chartsheet_set_zoom</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet, uint16_t scale)</td></tr>
<tr class="memdesc:a8e65099f374b986329f10ea9bfdcbce9"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set the chartsheet zoom factor.  <a href="chartsheet_8h.html#a8e65099f374b986329f10ea9bfdcbce9">More...</a><br /></td></tr>
<tr class="separator:a8e65099f374b986329f10ea9bfdcbce9"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a2bf101b1c468b4ac6edb0412c6a00350"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#a2bf101b1c468b4ac6edb0412c6a00350">chartsheet_set_landscape</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet)</td></tr>
<tr class="memdesc:a2bf101b1c468b4ac6edb0412c6a00350"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set the page orientation as landscape.  <a href="chartsheet_8h.html#a2bf101b1c468b4ac6edb0412c6a00350">More...</a><br /></td></tr>
<tr class="separator:a2bf101b1c468b4ac6edb0412c6a00350"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a78bd8a7e54b4a14211945e736c06c4c1"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#a78bd8a7e54b4a14211945e736c06c4c1">chartsheet_set_portrait</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet)</td></tr>
<tr class="memdesc:a78bd8a7e54b4a14211945e736c06c4c1"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set the page orientation as portrait.  <a href="chartsheet_8h.html#a78bd8a7e54b4a14211945e736c06c4c1">More...</a><br /></td></tr>
<tr class="separator:a78bd8a7e54b4a14211945e736c06c4c1"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a85f28014b3bbeb621402429e046ed438"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#a85f28014b3bbeb621402429e046ed438">chartsheet_set_paper</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet, uint8_t paper_type)</td></tr>
<tr class="memdesc:a85f28014b3bbeb621402429e046ed438"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set the paper type for printing.  <a href="chartsheet_8h.html#a85f28014b3bbeb621402429e046ed438">More...</a><br /></td></tr>
<tr class="separator:a85f28014b3bbeb621402429e046ed438"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a3300ba6239f4f9d559b5cd11e04076df"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#a3300ba6239f4f9d559b5cd11e04076df">chartsheet_set_margins</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet, double left, double right, double top, double bottom)</td></tr>
<tr class="memdesc:a3300ba6239f4f9d559b5cd11e04076df"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set the chartsheet margins for the printed page.  <a href="chartsheet_8h.html#a3300ba6239f4f9d559b5cd11e04076df">More...</a><br /></td></tr>
<tr class="separator:a3300ba6239f4f9d559b5cd11e04076df"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a8e45b9c97f5bc76a74025c69c37bb018"><td class="memItemLeft" align="right" valign="top"><a class="el" href="common_8h.html#a04b59aa3c578bc75f88ac16a979c5fe6">lxw_error</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#a8e45b9c97f5bc76a74025c69c37bb018">chartsheet_set_header</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet, const char *string)</td></tr>
<tr class="memdesc:a8e45b9c97f5bc76a74025c69c37bb018"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set the printed page header caption.  <a href="chartsheet_8h.html#a8e45b9c97f5bc76a74025c69c37bb018">More...</a><br /></td></tr>
<tr class="separator:a8e45b9c97f5bc76a74025c69c37bb018"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aa3a78449c628b042c604db906db5b75c"><td class="memItemLeft" align="right" valign="top"><a class="el" href="common_8h.html#a04b59aa3c578bc75f88ac16a979c5fe6">lxw_error</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#aa3a78449c628b042c604db906db5b75c">chartsheet_set_footer</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet, const char *string)</td></tr>
<tr class="memdesc:aa3a78449c628b042c604db906db5b75c"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set the printed page footer caption.  <a href="chartsheet_8h.html#aa3a78449c628b042c604db906db5b75c">More...</a><br /></td></tr>
<tr class="separator:aa3a78449c628b042c604db906db5b75c"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a68c4f676ef8d16bfe5ec834d29df9554"><td class="memItemLeft" align="right" valign="top"><a class="el" href="common_8h.html#a04b59aa3c578bc75f88ac16a979c5fe6">lxw_error</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#a68c4f676ef8d16bfe5ec834d29df9554">chartsheet_set_header_opt</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet, const char *string, <a class="el" href="structlxw__header__footer__options.html">lxw_header_footer_options</a> *options)</td></tr>
<tr class="memdesc:a68c4f676ef8d16bfe5ec834d29df9554"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set the printed page header caption with additional options.  <a href="chartsheet_8h.html#a68c4f676ef8d16bfe5ec834d29df9554">More...</a><br /></td></tr>
<tr class="separator:a68c4f676ef8d16bfe5ec834d29df9554"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ad6085cbf62a686be1aa25604b8abf839"><td class="memItemLeft" align="right" valign="top"><a class="el" href="common_8h.html#a04b59aa3c578bc75f88ac16a979c5fe6">lxw_error</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#ad6085cbf62a686be1aa25604b8abf839">chartsheet_set_footer_opt</a> (<a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet, const char *string, <a class="el" href="structlxw__header__footer__options.html">lxw_header_footer_options</a> *options)</td></tr>
<tr class="memdesc:ad6085cbf62a686be1aa25604b8abf839"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set the printed page footer caption with additional options.  <a href="chartsheet_8h.html#ad6085cbf62a686be1aa25604b8abf839">More...</a><br /></td></tr>
<tr class="separator:ad6085cbf62a686be1aa25604b8abf839"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table>
<h2 class="groupheader">Function Documentation</h2>
<a id="a1c2cc87b14539396de75cd59ab2a6031"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a1c2cc87b14539396de75cd59ab2a6031">&#9670;&nbsp;</a></span>chartsheet_set_chart()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="common_8h.html#a04b59aa3c578bc75f88ac16a979c5fe6">lxw_error</a> chartsheet_set_chart </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="structlxw__chart.html">lxw_chart</a> *&#160;</td>
          <td class="paramname"><em>chart</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated. </td></tr>
    <tr><td class="paramname">chart</td><td>A <a class="el" href="structlxw__chart.html" title="Struct to represent an Excel chart.">lxw_chart</a> object created via <a class="el" href="workbook_8h.html#a63b001ecefdbc4417986a3e344657726" title="Create a new chart to be added to a worksheet:">workbook_add_chart()</a>.</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>A <a class="el" href="common_8h.html#a96384aee66a82d783d695374078e1ea9" title="Error codes from libxlsxwriter functions.">lxw_error</a> code.</dd></dl>
<p>The <code>chartsheet_set_chart()</code> function can be used to insert a chart into a chartsheet. The chart object must be created first using the <code><a class="el" href="workbook_8h.html#a63b001ecefdbc4417986a3e344657726" title="Create a new chart to be added to a worksheet:">workbook_add_chart()</a></code> function and configured using the <a class="el" href="chart_8h.html">chart.h</a> functions.</p>
<div class="fragment"><div class="line"><span class="comment">// Create the chartsheet.</span></div>
<div class="line"><a class="code" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet = <a class="code" href="workbook_8h.html#a9cb69c057990a4139f0a19b53b04b805">workbook_add_chartsheet</a>(workbook, NULL);</div>
<div class="line"> </div>
<div class="line"><span class="comment">// Create a chart object.</span></div>
<div class="line"><a class="code" href="structlxw__chart.html">lxw_chart</a> *chart = <a class="code" href="workbook_8h.html#a63b001ecefdbc4417986a3e344657726">workbook_add_chart</a>(workbook, <a class="code" href="chart_8h.html#a9f577b0fcabe6cac9118a26a483fe85caf309b18af571c90d3ae052e769d30e6c">LXW_CHART_LINE</a>);</div>
<div class="line"> </div>
<div class="line"><span class="comment">// Add a data series to the chart.</span></div>
<div class="line"><a class="code" href="chart_8h.html#ad60de0eb056e93435407e91482115f55">chart_add_series</a>(chart, NULL, <span class="stringliteral">&quot;=Sheet1!$A$1:$A$6&quot;</span>);</div>
<div class="line"> </div>
<div class="line"><span class="comment">// Insert the chart into the chartsheet.</span></div>
<div class="line"><a class="code" href="chartsheet_8h.html#a1c2cc87b14539396de75cd59ab2a6031">chartsheet_set_chart</a>(chartsheet, chart);</div>
</div><!-- fragment --><div class="image">
<img src="chartsheet2.png" alt=""/>
</div>
<p><b>Note:</b></p>
<p>A chart may only be inserted once into a chartsheet or a worksheet. If several similar charts are required then each one must be created separately. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="chartsheet_8c-example.html#a26">chartsheet.c</a>.</dd>
</dl>

</div>
</div>
<a id="a169a4a2ec5b7d57abe02feb9fc22023b"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a169a4a2ec5b7d57abe02feb9fc22023b">&#9670;&nbsp;</a></span>chartsheet_activate()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void chartsheet_activate </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated.</td></tr>
  </table>
  </dd>
</dl>
<p>The <code>chartsheet_activate()</code> function is used to specify which chartsheet is initially visible in a multi-sheet workbook:</p>
<div class="fragment"><div class="line"><a class="code" href="structlxw__worksheet.html">lxw_worksheet</a>  *worksheet1  = <a class="code" href="workbook_8h.html#a81d456b4f65a464e78e4a0030ecc3c2e">workbook_add_worksheet</a>(workbook, NULL);</div>
<div class="line"><a class="code" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet1 = <a class="code" href="workbook_8h.html#a9cb69c057990a4139f0a19b53b04b805">workbook_add_chartsheet</a>(workbook, NULL);</div>
<div class="line"><a class="code" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet2 = <a class="code" href="workbook_8h.html#a9cb69c057990a4139f0a19b53b04b805">workbook_add_chartsheet</a>(workbook, NULL);</div>
<div class="line"><a class="code" href="structlxw__chartsheet.html">lxw_chartsheet</a> *chartsheet3 = <a class="code" href="workbook_8h.html#a9cb69c057990a4139f0a19b53b04b805">workbook_add_chartsheet</a>(workbook, NULL);</div>
<div class="line"> </div>
<div class="line"><a class="code" href="chartsheet_8h.html#a169a4a2ec5b7d57abe02feb9fc22023b">chartsheet_activate</a>(chartsheet3);</div>
</div><!-- fragment --><div class="image">
<img src="chartsheet_activate.png" alt=""/>
</div>
<p>More than one chartsheet can be selected via the <code><a class="el" href="chartsheet_8h.html#a50e5acf866495f81e227bd99bc9f8e8b" title="Set a chartsheet tab as selected.">chartsheet_select()</a></code> function, see below, however only one chartsheet can be active.</p>
<p>The default active chartsheet is the first chartsheet.</p>
<p>See also <code><a class="el" href="worksheet_8h.html#a76ec76f91328c512d3d86a35642f0a08" title="Make a worksheet the active, i.e., visible worksheet.">worksheet_activate()</a></code>. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="chartsheet_8c-example.html#a27">chartsheet.c</a>.</dd>
</dl>

</div>
</div>
<a id="a50e5acf866495f81e227bd99bc9f8e8b"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a50e5acf866495f81e227bd99bc9f8e8b">&#9670;&nbsp;</a></span>chartsheet_select()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void chartsheet_select </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated.</td></tr>
  </table>
  </dd>
</dl>
<p>The <code>chartsheet_select()</code> function is used to indicate that a chartsheet is selected in a multi-sheet workbook:</p>
<div class="fragment"><div class="line"><a class="code" href="chartsheet_8h.html#a169a4a2ec5b7d57abe02feb9fc22023b">chartsheet_activate</a>(chartsheet1);</div>
<div class="line"><a class="code" href="chartsheet_8h.html#a50e5acf866495f81e227bd99bc9f8e8b">chartsheet_select</a>(chartsheet2);</div>
<div class="line"><a class="code" href="chartsheet_8h.html#a50e5acf866495f81e227bd99bc9f8e8b">chartsheet_select</a>(chartsheet3);</div>
</div><!-- fragment --><p>A selected chartsheet has its tab highlighted. Selecting chartsheets is a way of grouping them together so that, for example, several chartsheets could be printed in one go. A chartsheet that has been activated via the <code><a class="el" href="chartsheet_8h.html#a169a4a2ec5b7d57abe02feb9fc22023b" title="Make a chartsheet the active, i.e., visible chartsheet.">chartsheet_activate()</a></code> function will also appear as selected.</p>
<p>See also <code><a class="el" href="worksheet_8h.html#a78bfe3a786149deca69248db57da182f" title="Set a worksheet tab as selected.">worksheet_select()</a></code>. </p>

</div>
</div>
<a id="a350f52a5de9988662af0f99f4592ac64"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a350f52a5de9988662af0f99f4592ac64">&#9670;&nbsp;</a></span>chartsheet_hide()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void chartsheet_hide </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated.</td></tr>
  </table>
  </dd>
</dl>
<p>The <code>chartsheet_hide()</code> function is used to hide a chartsheet:</p>
<div class="fragment"><div class="line"><a class="code" href="chartsheet_8h.html#a350f52a5de9988662af0f99f4592ac64">chartsheet_hide</a>(chartsheet2);</div>
</div><!-- fragment --><p>You may wish to hide a chartsheet in order to avoid confusing a user with intermediate data or calculations.</p>
<div class="image">
<img src="hide_sheet.png" alt=""/>
</div>
<p>A hidden chartsheet can not be activated or selected so this function is mutually exclusive with the <code><a class="el" href="chartsheet_8h.html#a169a4a2ec5b7d57abe02feb9fc22023b" title="Make a chartsheet the active, i.e., visible chartsheet.">chartsheet_activate()</a></code> and <code><a class="el" href="chartsheet_8h.html#a50e5acf866495f81e227bd99bc9f8e8b" title="Set a chartsheet tab as selected.">chartsheet_select()</a></code> functions. In addition, since the first chartsheet will default to being the active chartsheet, you cannot hide the first chartsheet without activating another sheet:</p>
<div class="fragment"><div class="line"><a class="code" href="chartsheet_8h.html#a169a4a2ec5b7d57abe02feb9fc22023b">chartsheet_activate</a>(chartsheet2);</div>
<div class="line"><a class="code" href="chartsheet_8h.html#a350f52a5de9988662af0f99f4592ac64">chartsheet_hide</a>(chartsheet1);</div>
</div><!-- fragment --><p>See also <code><a class="el" href="worksheet_8h.html#a180fcbcf012b5c165a01490d1128dc11" title="Hide the current worksheet.">worksheet_hide()</a></code>. </p>

</div>
</div>
<a id="a54addfc00908f1c910ab12024a1deb7f"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a54addfc00908f1c910ab12024a1deb7f">&#9670;&nbsp;</a></span>chartsheet_set_first_sheet()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void chartsheet_set_first_sheet </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated.</td></tr>
  </table>
  </dd>
</dl>
<p>The <code><a class="el" href="chartsheet_8h.html#a169a4a2ec5b7d57abe02feb9fc22023b" title="Make a chartsheet the active, i.e., visible chartsheet.">chartsheet_activate()</a></code> function determines which chartsheet is initially selected. However, if there are a large number of chartsheets the selected chartsheet may not appear on the screen. To avoid this you can select the leftmost visible chartsheet tab using <code>chartsheet_set_first_sheet()</code>:</p>
<div class="fragment"><div class="line"><a class="code" href="chartsheet_8h.html#a54addfc00908f1c910ab12024a1deb7f">chartsheet_set_first_sheet</a>(chartsheet19); <span class="comment">// First visible chartsheet tab.</span></div>
<div class="line"><a class="code" href="chartsheet_8h.html#a169a4a2ec5b7d57abe02feb9fc22023b">chartsheet_activate</a>(chartsheet20);        <span class="comment">// First visible chartsheet.</span></div>
</div><!-- fragment --><p>This function is not required very often. The default value is the first chartsheet.</p>
<p>See also <code><a class="el" href="worksheet_8h.html#a463c8d3247f56e0ec191b148355f42f0" title="Set current worksheet as the first visible sheet tab.">worksheet_set_first_sheet()</a></code>. </p>

</div>
</div>
<a id="ad4128360dead5256f6ccdb2430b6a19b"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ad4128360dead5256f6ccdb2430b6a19b">&#9670;&nbsp;</a></span>chartsheet_set_tab_color()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void chartsheet_set_tab_color </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="format_8h.html#a34a05058edd856109e5bcf1cc6739fc9">lxw_color_t</a>&#160;</td>
          <td class="paramname"><em>color</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated. </td></tr>
    <tr><td class="paramname">color</td><td>The tab color.</td></tr>
  </table>
  </dd>
</dl>
<p>The <code>chartsheet_set_tab_color()</code> function is used to change the color of the chartsheet tab:</p>
<div class="fragment"><div class="line"><a class="code" href="chartsheet_8h.html#ad4128360dead5256f6ccdb2430b6a19b">chartsheet_set_tab_color</a>(chartsheet1, <a class="code" href="format_8h.html#abeafc6e8222ba9fcfd4f2c2f4e9ea38baedd7412491d9f34fc5f947ada9d196ec">LXW_COLOR_RED</a>);</div>
<div class="line"><a class="code" href="chartsheet_8h.html#ad4128360dead5256f6ccdb2430b6a19b">chartsheet_set_tab_color</a>(chartsheet2, <a class="code" href="format_8h.html#abeafc6e8222ba9fcfd4f2c2f4e9ea38bae0b5c39ced3b8c871974f0e4917e4871">LXW_COLOR_GREEN</a>);</div>
<div class="line"><a class="code" href="chartsheet_8h.html#ad4128360dead5256f6ccdb2430b6a19b">chartsheet_set_tab_color</a>(chartsheet3, 0xFF9900); <span class="comment">// Orange.</span></div>
</div><!-- fragment --><p>The color should be an RGB integer value, see <a class="el" href="working_with_colors.html">Working with Colors</a>.</p>
<p>See also <code><a class="el" href="worksheet_8h.html#a1e84ef4dff791fc2278dfb029af94cb0" title="Set the color of the worksheet tab.">worksheet_set_tab_color()</a></code>. </p>

</div>
</div>
<a id="a16d7a783d2b4ff43725d5e2b16c2eeef"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a16d7a783d2b4ff43725d5e2b16c2eeef">&#9670;&nbsp;</a></span>chartsheet_protect()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void chartsheet_protect </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">const char *&#160;</td>
          <td class="paramname"><em>password</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="structlxw__protection.html">lxw_protection</a> *&#160;</td>
          <td class="paramname"><em>options</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated. </td></tr>
    <tr><td class="paramname">password</td><td>A chartsheet password. </td></tr>
    <tr><td class="paramname">options</td><td>Chartsheet elements to protect.</td></tr>
  </table>
  </dd>
</dl>
<p>The <code>chartsheet_protect()</code> function protects chartsheet elements from modification:</p>
<div class="fragment"><div class="line"><a class="code" href="chartsheet_8h.html#a16d7a783d2b4ff43725d5e2b16c2eeef">chartsheet_protect</a>(chartsheet, <span class="stringliteral">&quot;Some Password&quot;</span>, options);</div>
</div><!-- fragment --><p>The <code>password</code> and <a class="el" href="structlxw__protection.html" title="Worksheet protection options.">lxw_protection</a> pointer are both optional:</p>
<div class="fragment"><div class="line"><a class="code" href="chartsheet_8h.html#a16d7a783d2b4ff43725d5e2b16c2eeef">chartsheet_protect</a>(chartsheet2, NULL,       my_options);</div>
<div class="line"><a class="code" href="chartsheet_8h.html#a16d7a783d2b4ff43725d5e2b16c2eeef">chartsheet_protect</a>(chartsheet3, <span class="stringliteral">&quot;password&quot;</span>, NULL);</div>
<div class="line"><a class="code" href="chartsheet_8h.html#a16d7a783d2b4ff43725d5e2b16c2eeef">chartsheet_protect</a>(chartsheet4, <span class="stringliteral">&quot;password&quot;</span>, my_options);</div>
</div><!-- fragment --><p>Passing a <code>NULL</code> password is the same as turning on protection without a password. Passing a <code>NULL</code> password and <code>NULL</code> options had no effect on chartsheets.</p>
<p>You can specify which chartsheet elements you wish to protect by passing a <a class="el" href="structlxw__protection.html" title="Worksheet protection options.">lxw_protection</a> pointer in the <code>options</code> argument. In Excel chartsheets only have two protection options: </p><pre class="fragment">no_content
no_objects
</pre><p>All parameters are off by default. Individual elements can be protected as follows:</p>
<div class="fragment"><div class="line"><a class="code" href="structlxw__protection.html">lxw_protection</a> options = {</div>
<div class="line">    .<a class="code" href="structlxw__protection.html#afea5e584eb539965ee41d582a4dbab0d">no_content</a>  = 1,</div>
<div class="line">    .no_objects  = 1,</div>
<div class="line">};</div>
<div class="line"> </div>
<div class="line"><a class="code" href="chartsheet_8h.html#a16d7a783d2b4ff43725d5e2b16c2eeef">chartsheet_protect</a>(chartsheet, NULL, &amp;options);</div>
</div><!-- fragment --><p>See also <a class="el" href="worksheet_8h.html#a1b49e135d4debcdb25941f2f40f04cb0" title="Protect elements of a worksheet from modification.">worksheet_protect()</a>.</p>
<p><b>Note:</b> Sheet level passwords in Excel offer <b>very</b> weak protection. They don't encrypt your data and are very easy to deactivate. Full workbook encryption is not supported by <code>libxlsxwriter</code> since it requires a completely different file format. </p>

</div>
</div>
<a id="a8e65099f374b986329f10ea9bfdcbce9"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a8e65099f374b986329f10ea9bfdcbce9">&#9670;&nbsp;</a></span>chartsheet_set_zoom()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void chartsheet_set_zoom </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">uint16_t&#160;</td>
          <td class="paramname"><em>scale</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated. </td></tr>
    <tr><td class="paramname">scale</td><td>Chartsheet zoom factor.</td></tr>
  </table>
  </dd>
</dl>
<p>Set the chartsheet zoom factor in the range <code>10 &lt;= zoom &lt;= 400</code>:</p>
<div class="fragment"><div class="line"><a class="code" href="chartsheet_8h.html#a8e65099f374b986329f10ea9bfdcbce9">chartsheet_set_zoom</a>(chartsheet, 75);</div>
</div><!-- fragment --><p>The default zoom factor is 100. It isn't possible to set the zoom to "Selection" because it is calculated by Excel at run-time.</p>
<p>See also <code><a class="el" href="worksheet_8h.html#a38e16dc0a2e75d7ec99dca21fbeec89b" title="Set the worksheet zoom factor.">worksheet_set_zoom()</a></code>. </p>

</div>
</div>
<a id="a2bf101b1c468b4ac6edb0412c6a00350"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a2bf101b1c468b4ac6edb0412c6a00350">&#9670;&nbsp;</a></span>chartsheet_set_landscape()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void chartsheet_set_landscape </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated.</td></tr>
  </table>
  </dd>
</dl>
<p>This function is used to set the orientation of a chartsheet's printed page to landscape. The default chartsheet orientation is landscape, so this function isn't generally required:</p>
<div class="fragment"><div class="line"><a class="code" href="chartsheet_8h.html#a2bf101b1c468b4ac6edb0412c6a00350">chartsheet_set_landscape</a>(chartsheet);</div>
</div><!-- fragment --> 
</div>
</div>
<a id="a78bd8a7e54b4a14211945e736c06c4c1"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a78bd8a7e54b4a14211945e736c06c4c1">&#9670;&nbsp;</a></span>chartsheet_set_portrait()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void chartsheet_set_portrait </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated.</td></tr>
  </table>
  </dd>
</dl>
<p>This function is used to set the orientation of a chartsheet's printed page to portrait:</p>
<div class="fragment"><div class="line"><a class="code" href="chartsheet_8h.html#a78bd8a7e54b4a14211945e736c06c4c1">chartsheet_set_portrait</a>(chartsheet);</div>
</div><!-- fragment --> 
</div>
</div>
<a id="a85f28014b3bbeb621402429e046ed438"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a85f28014b3bbeb621402429e046ed438">&#9670;&nbsp;</a></span>chartsheet_set_paper()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void chartsheet_set_paper </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">uint8_t&#160;</td>
          <td class="paramname"><em>paper_type</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated. </td></tr>
    <tr><td class="paramname">paper_type</td><td>The Excel paper format type.</td></tr>
  </table>
  </dd>
</dl>
<p>This function is used to set the paper format for the printed output of a chartsheet:</p>
<div class="fragment"><div class="line"><a class="code" href="chartsheet_8h.html#a85f28014b3bbeb621402429e046ed438">chartsheet_set_paper</a>(chartsheet1, 1);  <span class="comment">// US Letter</span></div>
<div class="line"><a class="code" href="chartsheet_8h.html#a85f28014b3bbeb621402429e046ed438">chartsheet_set_paper</a>(chartsheet2, 9);  <span class="comment">// A4</span></div>
</div><!-- fragment --><p>If you do not specify a paper type the chartsheet will print using the printer's default paper style.</p>
<p>See <code><a class="el" href="worksheet_8h.html#a9f8af12017797b10c5ee68e04149032f" title="Set the paper type for printing.">worksheet_set_paper()</a></code> for a full list of available paper sizes. </p>

</div>
</div>
<a id="a3300ba6239f4f9d559b5cd11e04076df"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a3300ba6239f4f9d559b5cd11e04076df">&#9670;&nbsp;</a></span>chartsheet_set_margins()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void chartsheet_set_margins </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">double&#160;</td>
          <td class="paramname"><em>left</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">double&#160;</td>
          <td class="paramname"><em>right</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">double&#160;</td>
          <td class="paramname"><em>top</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">double&#160;</td>
          <td class="paramname"><em>bottom</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated. </td></tr>
    <tr><td class="paramname">left</td><td>Left margin in inches. Excel default is 0.7. </td></tr>
    <tr><td class="paramname">right</td><td>Right margin in inches. Excel default is 0.7. </td></tr>
    <tr><td class="paramname">top</td><td>Top margin in inches. Excel default is 0.75. </td></tr>
    <tr><td class="paramname">bottom</td><td>Bottom margin in inches. Excel default is 0.75.</td></tr>
  </table>
  </dd>
</dl>
<p>The <code>chartsheet_set_margins()</code> function is used to set the margins of the chartsheet when it is printed. The units are in inches. Specifying <code>-1</code> for any parameter will give the default Excel value as shown above.</p>
<div class="fragment"><div class="line"><a class="code" href="chartsheet_8h.html#a3300ba6239f4f9d559b5cd11e04076df">chartsheet_set_margins</a>(chartsheet, 1.3, 1.2, -1, -1);</div>
</div><!-- fragment --> 
</div>
</div>
<a id="a8e45b9c97f5bc76a74025c69c37bb018"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a8e45b9c97f5bc76a74025c69c37bb018">&#9670;&nbsp;</a></span>chartsheet_set_header()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="common_8h.html#a04b59aa3c578bc75f88ac16a979c5fe6">lxw_error</a> chartsheet_set_header </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">const char *&#160;</td>
          <td class="paramname"><em>string</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated. </td></tr>
    <tr><td class="paramname">string</td><td>The header string.</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>A <a class="el" href="common_8h.html#a96384aee66a82d783d695374078e1ea9" title="Error codes from libxlsxwriter functions.">lxw_error</a> code.</dd></dl>
<p>Headers and footers are generated using a string which is a combination of plain text and control characters</p>
<div class="fragment"><div class="line"><a class="code" href="chartsheet_8h.html#a8e45b9c97f5bc76a74025c69c37bb018">chartsheet_set_header</a>(chartsheet, <span class="stringliteral">&quot;&amp;LHello&quot;</span>);</div>
<div class="line"> </div>
<div class="line"><span class="comment">//     ---------------------------------------------------------------</span></div>
<div class="line"><span class="comment">//    |                                                               |</span></div>
<div class="line"><span class="comment">//    | Hello                                                         |</span></div>
<div class="line"><span class="comment">//    |                                                               |</span></div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line"><a class="code" href="chartsheet_8h.html#a8e45b9c97f5bc76a74025c69c37bb018">chartsheet_set_header</a>(chartsheet, <span class="stringliteral">&quot;&amp;CHello&quot;</span>);</div>
<div class="line"> </div>
<div class="line"><span class="comment">//     ---------------------------------------------------------------</span></div>
<div class="line"><span class="comment">//    |                                                               |</span></div>
<div class="line"><span class="comment">//    |                          Hello                                |</span></div>
<div class="line"><span class="comment">//    |                                                               |</span></div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line"><a class="code" href="chartsheet_8h.html#a8e45b9c97f5bc76a74025c69c37bb018">chartsheet_set_header</a>(chartsheet, <span class="stringliteral">&quot;&amp;RHello&quot;</span>);</div>
<div class="line"> </div>
<div class="line"><span class="comment">//     ---------------------------------------------------------------</span></div>
<div class="line"><span class="comment">//    |                                                               |</span></div>
<div class="line"><span class="comment">//    |                                                         Hello |</span></div>
<div class="line"><span class="comment">//    |                                                               |</span></div>
</div><!-- fragment --><p>See <code><a class="el" href="worksheet_8h.html#a4070c24ed5107f33e94f30a1bf865ba9" title="Set the printed page header caption.">worksheet_set_header()</a></code> for a full explanation of the syntax of Excel's header formatting and control characters. </p>

</div>
</div>
<a id="aa3a78449c628b042c604db906db5b75c"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aa3a78449c628b042c604db906db5b75c">&#9670;&nbsp;</a></span>chartsheet_set_footer()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="common_8h.html#a04b59aa3c578bc75f88ac16a979c5fe6">lxw_error</a> chartsheet_set_footer </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">const char *&#160;</td>
          <td class="paramname"><em>string</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated. </td></tr>
    <tr><td class="paramname">string</td><td>The footer string.</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>A <a class="el" href="common_8h.html#a96384aee66a82d783d695374078e1ea9" title="Error codes from libxlsxwriter functions.">lxw_error</a> code.</dd></dl>
<p>The syntax of this function is the same as <a class="el" href="chartsheet_8h.html#a8e45b9c97f5bc76a74025c69c37bb018" title="Set the printed page header caption.">chartsheet_set_header()</a>. </p>

</div>
</div>
<a id="a68c4f676ef8d16bfe5ec834d29df9554"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a68c4f676ef8d16bfe5ec834d29df9554">&#9670;&nbsp;</a></span>chartsheet_set_header_opt()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="common_8h.html#a04b59aa3c578bc75f88ac16a979c5fe6">lxw_error</a> chartsheet_set_header_opt </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">const char *&#160;</td>
          <td class="paramname"><em>string</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="structlxw__header__footer__options.html">lxw_header_footer_options</a> *&#160;</td>
          <td class="paramname"><em>options</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated. </td></tr>
    <tr><td class="paramname">string</td><td>The header string. </td></tr>
    <tr><td class="paramname">options</td><td>Header options.</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>A <a class="el" href="common_8h.html#a96384aee66a82d783d695374078e1ea9" title="Error codes from libxlsxwriter functions.">lxw_error</a> code.</dd></dl>
<p>The syntax of this function is the same as <a class="el" href="chartsheet_8h.html#a8e45b9c97f5bc76a74025c69c37bb018" title="Set the printed page header caption.">chartsheet_set_header()</a> with an additional parameter to specify options for the header.</p>
<p>Currently, the only available option is the header margin:</p>
<div class="fragment"><div class="line"><a class="code" href="structlxw__header__footer__options.html">lxw_header_footer_options</a> header_options = { 0.2 };</div>
<div class="line"> </div>
<div class="line"><a class="code" href="chartsheet_8h.html#a68c4f676ef8d16bfe5ec834d29df9554">chartsheet_set_header_opt</a>(chartsheet, <span class="stringliteral">&quot;Some text&quot;</span>, &amp;header_options);</div>
</div><!-- fragment --> 
</div>
</div>
<a id="ad6085cbf62a686be1aa25604b8abf839"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ad6085cbf62a686be1aa25604b8abf839">&#9670;&nbsp;</a></span>chartsheet_set_footer_opt()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="common_8h.html#a04b59aa3c578bc75f88ac16a979c5fe6">lxw_error</a> chartsheet_set_footer_opt </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> *&#160;</td>
          <td class="paramname"><em>chartsheet</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">const char *&#160;</td>
          <td class="paramname"><em>string</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="structlxw__header__footer__options.html">lxw_header_footer_options</a> *&#160;</td>
          <td class="paramname"><em>options</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">chartsheet</td><td>Pointer to a <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> instance to be updated. </td></tr>
    <tr><td class="paramname">string</td><td>The footer string. </td></tr>
    <tr><td class="paramname">options</td><td>Footer options.</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>A <a class="el" href="common_8h.html#a96384aee66a82d783d695374078e1ea9" title="Error codes from libxlsxwriter functions.">lxw_error</a> code.</dd></dl>
<p>The syntax of this function is the same as <a class="el" href="chartsheet_8h.html#a68c4f676ef8d16bfe5ec834d29df9554" title="Set the printed page header caption with additional options.">chartsheet_set_header_opt()</a>. </p>

</div>
</div>
<h2 class="groupheader">Typedef Documentation</h2>
<a id="abe5d2347bafd0d6d746216738269e8f2"></a>
<h2 class="memtitle"><span class="permalink"><a href="#abe5d2347bafd0d6d746216738269e8f2">&#9670;&nbsp;</a></span>lxw_chartsheet</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">typedef struct <a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a> <a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a></td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The members of the <a class="el" href="structlxw__chartsheet.html" title="Struct to represent an Excel chartsheet.">lxw_chartsheet</a> struct aren't modified directly. Instead the chartsheet properties are set by calling the functions shown in <a class="el" href="chartsheet_8h.html" title="Functions related to adding data and formatting to a chartsheet.">chartsheet.h</a>. </p>

</div>
</div>
<table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="nested-classes"></a>
Data Structures</h2></td></tr>
<tr class="memitem:"><td class="memItemLeft" align="right" valign="top">struct &#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a></td></tr>
<tr class="memdesc:"><td class="mdescLeft">&#160;</td><td class="mdescRight">Struct to represent an Excel chartsheet.  <a href="structlxw__chartsheet.html#details">More...</a><br /></td></tr>
<tr class="separator:"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="typedef-members"></a>
Typedefs</h2></td></tr>
<tr class="memitem:abe5d2347bafd0d6d746216738269e8f2"><td class="memItemLeft" align="right" valign="top">typedef struct <a class="el" href="structlxw__chartsheet.html">lxw_chartsheet</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="chartsheet_8h.html#abe5d2347bafd0d6d746216738269e8f2">lxw_chartsheet</a></td></tr>
<tr class="memdesc:abe5d2347bafd0d6d746216738269e8f2"><td class="mdescLeft">&#160;</td><td class="mdescRight">Struct to represent an Excel chartsheet.  <a href="chartsheet_8h.html#abe5d2347bafd0d6d746216738269e8f2">More...</a><br /></td></tr>
<tr class="separator:abe5d2347bafd0d6d746216738269e8f2"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table>
</div><!-- contents -->
<div class="ttc" id="aworkbook_8h_html_a9cb69c057990a4139f0a19b53b04b805"><div class="ttname"><a href="workbook_8h.html#a9cb69c057990a4139f0a19b53b04b805">workbook_add_chartsheet</a></div><div class="ttdeci">lxw_chartsheet * workbook_add_chartsheet(lxw_workbook *workbook, const char *sheetname)</div><div class="ttdoc">Add a new chartsheet to a workbook.</div></div>
<div class="ttc" id="aworkbook_8h_html_ad9e7aeebc0fd43562db5bcd527b2ee5e"><div class="ttname"><a href="workbook_8h.html#ad9e7aeebc0fd43562db5bcd527b2ee5e">workbook_close</a></div><div class="ttdeci">lxw_error workbook_close(lxw_workbook *workbook)</div><div class="ttdoc">Close the Workbook object and write the XLSX file.</div></div>
<div class="ttc" id="achartsheet_8h_html_a3300ba6239f4f9d559b5cd11e04076df"><div class="ttname"><a href="chartsheet_8h.html#a3300ba6239f4f9d559b5cd11e04076df">chartsheet_set_margins</a></div><div class="ttdeci">void chartsheet_set_margins(lxw_chartsheet *chartsheet, double left, double right, double top, double bottom)</div><div class="ttdoc">Set the chartsheet margins for the printed page.</div></div>
<div class="ttc" id="achartsheet_8h_html_a169a4a2ec5b7d57abe02feb9fc22023b"><div class="ttname"><a href="chartsheet_8h.html#a169a4a2ec5b7d57abe02feb9fc22023b">chartsheet_activate</a></div><div class="ttdeci">void chartsheet_activate(lxw_chartsheet *chartsheet)</div><div class="ttdoc">Make a chartsheet the active, i.e., visible chartsheet.</div></div>
<div class="ttc" id="astructlxw__protection_html"><div class="ttname"><a href="structlxw__protection.html">lxw_protection</a></div><div class="ttdoc">Worksheet protection options.</div><div class="ttdef"><b>Definition:</b> worksheet.h:1499</div></div>
<div class="ttc" id="achartsheet_8h_html_a85f28014b3bbeb621402429e046ed438"><div class="ttname"><a href="chartsheet_8h.html#a85f28014b3bbeb621402429e046ed438">chartsheet_set_paper</a></div><div class="ttdeci">void chartsheet_set_paper(lxw_chartsheet *chartsheet, uint8_t paper_type)</div><div class="ttdoc">Set the paper type for printing.</div></div>
<div class="ttc" id="achart_8h_html_ad60de0eb056e93435407e91482115f55"><div class="ttname"><a href="chart_8h.html#ad60de0eb056e93435407e91482115f55">chart_add_series</a></div><div class="ttdeci">lxw_chart_series * chart_add_series(lxw_chart *chart, const char *categories, const char *values)</div><div class="ttdoc">Add a data series to a chart.</div></div>
<div class="ttc" id="achartsheet_8h_html_a8e65099f374b986329f10ea9bfdcbce9"><div class="ttname"><a href="chartsheet_8h.html#a8e65099f374b986329f10ea9bfdcbce9">chartsheet_set_zoom</a></div><div class="ttdeci">void chartsheet_set_zoom(lxw_chartsheet *chartsheet, uint16_t scale)</div><div class="ttdoc">Set the chartsheet zoom factor.</div></div>
<div class="ttc" id="achartsheet_8h_html_ad4128360dead5256f6ccdb2430b6a19b"><div class="ttname"><a href="chartsheet_8h.html#ad4128360dead5256f6ccdb2430b6a19b">chartsheet_set_tab_color</a></div><div class="ttdeci">void chartsheet_set_tab_color(lxw_chartsheet *chartsheet, lxw_color_t color)</div><div class="ttdoc">Set the color of the chartsheet tab.</div></div>
<div class="ttc" id="astructlxw__protection_html_afea5e584eb539965ee41d582a4dbab0d"><div class="ttname"><a href="structlxw__protection.html#afea5e584eb539965ee41d582a4dbab0d">lxw_protection::no_content</a></div><div class="ttdeci">uint8_t no_content</div><div class="ttdef"><b>Definition:</b> worksheet.h:1546</div></div>
<div class="ttc" id="achartsheet_8h_html_a50e5acf866495f81e227bd99bc9f8e8b"><div class="ttname"><a href="chartsheet_8h.html#a50e5acf866495f81e227bd99bc9f8e8b">chartsheet_select</a></div><div class="ttdeci">void chartsheet_select(lxw_chartsheet *chartsheet)</div><div class="ttdoc">Set a chartsheet tab as selected.</div></div>
<div class="ttc" id="achart_8h_html_a9f577b0fcabe6cac9118a26a483fe85cab70e5b5cf00126d7040ab25af3b117d5"><div class="ttname"><a href="chart_8h.html#a9f577b0fcabe6cac9118a26a483fe85cab70e5b5cf00126d7040ab25af3b117d5">LXW_CHART_BAR</a></div><div class="ttdeci">@ LXW_CHART_BAR</div><div class="ttdef"><b>Definition:</b> chart.h:104</div></div>
<div class="ttc" id="achart_8h_html_a9f577b0fcabe6cac9118a26a483fe85caf309b18af571c90d3ae052e769d30e6c"><div class="ttname"><a href="chart_8h.html#a9f577b0fcabe6cac9118a26a483fe85caf309b18af571c90d3ae052e769d30e6c">LXW_CHART_LINE</a></div><div class="ttdeci">@ LXW_CHART_LINE</div><div class="ttdef"><b>Definition:</b> chart.h:125</div></div>
<div class="ttc" id="astructlxw__worksheet_html"><div class="ttname"><a href="structlxw__worksheet.html">lxw_worksheet</a></div><div class="ttdoc">Struct to represent an Excel worksheet.</div><div class="ttdef"><b>Definition:</b> worksheet.h:1603</div></div>
<div class="ttc" id="achartsheet_8h_html_a54addfc00908f1c910ab12024a1deb7f"><div class="ttname"><a href="chartsheet_8h.html#a54addfc00908f1c910ab12024a1deb7f">chartsheet_set_first_sheet</a></div><div class="ttdeci">void chartsheet_set_first_sheet(lxw_chartsheet *chartsheet)</div><div class="ttdoc">Set current chartsheet as the first visible sheet tab.</div></div>
<div class="ttc" id="achartsheet_8h_html_a68c4f676ef8d16bfe5ec834d29df9554"><div class="ttname"><a href="chartsheet_8h.html#a68c4f676ef8d16bfe5ec834d29df9554">chartsheet_set_header_opt</a></div><div class="ttdeci">lxw_error chartsheet_set_header_opt(lxw_chartsheet *chartsheet, const char *string, lxw_header_footer_options *options)</div><div class="ttdoc">Set the printed page header caption with additional options.</div></div>
<div class="ttc" id="astructlxw__chartsheet_html"><div class="ttname"><a href="structlxw__chartsheet.html">lxw_chartsheet</a></div><div class="ttdoc">Struct to represent an Excel chartsheet.</div><div class="ttdef"><b>Definition:</b> chartsheet.h:74</div></div>
<div class="ttc" id="astructlxw__chart_html"><div class="ttname"><a href="structlxw__chart.html">lxw_chart</a></div><div class="ttdoc">Struct to represent an Excel chart.</div><div class="ttdef"><b>Definition:</b> chart.h:1086</div></div>
<div class="ttc" id="achartsheet_8h_html_a2bf101b1c468b4ac6edb0412c6a00350"><div class="ttname"><a href="chartsheet_8h.html#a2bf101b1c468b4ac6edb0412c6a00350">chartsheet_set_landscape</a></div><div class="ttdeci">void chartsheet_set_landscape(lxw_chartsheet *chartsheet)</div><div class="ttdoc">Set the page orientation as landscape.</div></div>
<div class="ttc" id="aformat_8h_html_abeafc6e8222ba9fcfd4f2c2f4e9ea38bae0b5c39ced3b8c871974f0e4917e4871"><div class="ttname"><a href="format_8h.html#abeafc6e8222ba9fcfd4f2c2f4e9ea38bae0b5c39ced3b8c871974f0e4917e4871">LXW_COLOR_GREEN</a></div><div class="ttdeci">@ LXW_COLOR_GREEN</div><div class="ttdef"><b>Definition:</b> format.h:196</div></div>
<div class="ttc" id="achartsheet_8h_html_a350f52a5de9988662af0f99f4592ac64"><div class="ttname"><a href="chartsheet_8h.html#a350f52a5de9988662af0f99f4592ac64">chartsheet_hide</a></div><div class="ttdeci">void chartsheet_hide(lxw_chartsheet *chartsheet)</div><div class="ttdoc">Hide the current chartsheet.</div></div>
<div class="ttc" id="astructlxw__workbook_html"><div class="ttname"><a href="structlxw__workbook.html">lxw_workbook</a></div><div class="ttdoc">Struct to represent an Excel workbook.</div><div class="ttdef"><b>Definition:</b> workbook.h:273</div></div>
<div class="ttc" id="achartsheet_8h_html_a1c2cc87b14539396de75cd59ab2a6031"><div class="ttname"><a href="chartsheet_8h.html#a1c2cc87b14539396de75cd59ab2a6031">chartsheet_set_chart</a></div><div class="ttdeci">lxw_error chartsheet_set_chart(lxw_chartsheet *chartsheet, lxw_chart *chart)</div><div class="ttdoc">Insert a chart object into a chartsheet.</div></div>
<div class="ttc" id="aformat_8h_html_abeafc6e8222ba9fcfd4f2c2f4e9ea38baedd7412491d9f34fc5f947ada9d196ec"><div class="ttname"><a href="format_8h.html#abeafc6e8222ba9fcfd4f2c2f4e9ea38baedd7412491d9f34fc5f947ada9d196ec">LXW_COLOR_RED</a></div><div class="ttdeci">@ LXW_COLOR_RED</div><div class="ttdef"><b>Definition:</b> format.h:217</div></div>
<div class="ttc" id="astructlxw__header__footer__options_html"><div class="ttname"><a href="structlxw__header__footer__options.html">lxw_header_footer_options</a></div><div class="ttdoc">Header and footer options.</div><div class="ttdef"><b>Definition:</b> worksheet.h:1474</div></div>
<div class="ttc" id="achartsheet_8h_html_a78bd8a7e54b4a14211945e736c06c4c1"><div class="ttname"><a href="chartsheet_8h.html#a78bd8a7e54b4a14211945e736c06c4c1">chartsheet_set_portrait</a></div><div class="ttdeci">void chartsheet_set_portrait(lxw_chartsheet *chartsheet)</div><div class="ttdoc">Set the page orientation as portrait.</div></div>
<div class="ttc" id="achartsheet_8h_html_a8e45b9c97f5bc76a74025c69c37bb018"><div class="ttname"><a href="chartsheet_8h.html#a8e45b9c97f5bc76a74025c69c37bb018">chartsheet_set_header</a></div><div class="ttdeci">lxw_error chartsheet_set_header(lxw_chartsheet *chartsheet, const char *string)</div><div class="ttdoc">Set the printed page header caption.</div></div>
<div class="ttc" id="aworkbook_8h_html_a81d456b4f65a464e78e4a0030ecc3c2e"><div class="ttname"><a href="workbook_8h.html#a81d456b4f65a464e78e4a0030ecc3c2e">workbook_add_worksheet</a></div><div class="ttdeci">lxw_worksheet * workbook_add_worksheet(lxw_workbook *workbook, const char *sheetname)</div><div class="ttdoc">Add a new worksheet to a workbook.</div></div>
<div class="ttc" id="aworkbook_8h_html_a63b001ecefdbc4417986a3e344657726"><div class="ttname"><a href="workbook_8h.html#a63b001ecefdbc4417986a3e344657726">workbook_add_chart</a></div><div class="ttdeci">lxw_chart * workbook_add_chart(lxw_workbook *workbook, uint8_t chart_type)</div><div class="ttdoc">Create a new chart to be added to a worksheet:</div></div>
<div class="ttc" id="achartsheet_8h_html_a16d7a783d2b4ff43725d5e2b16c2eeef"><div class="ttname"><a href="chartsheet_8h.html#a16d7a783d2b4ff43725d5e2b16c2eeef">chartsheet_protect</a></div><div class="ttdeci">void chartsheet_protect(lxw_chartsheet *chartsheet, const char *password, lxw_protection *options)</div><div class="ttdoc">Protect elements of a chartsheet from modification.</div></div>
<!-- HTML footer for doxygen 1.8.20-->
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Copyright 2014-2020 John McNamara.
Generated by&#160;<a href="http://www.doxygen.org/index.html"><img class="footer" src="doxygen.svg" width="104" height="31" alt="doxygen"/></a> 1.8.20
</small></address>
</body>
</html>
